﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<%@ Register Assembly="FredCK.FCKeditorV2" Namespace="FredCK.FCKeditorV2" TagPrefix="FCKeditorV2" %>
<%@ Register src="admin/qljoblang.ascx" tagname="qljoblang" tagprefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataKeyNames="id,lang" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:CommandField ShowDeleteButton="True" />
            <asp:BoundField DataField="id" HeaderText="id" ReadOnly="True" 
                SortExpression="id" />
            <asp:BoundField DataField="lang" HeaderText="lang" ReadOnly="True" 
                SortExpression="lang" />
            <asp:BoundField DataField="menu" HeaderText="menu" SortExpression="menu" />
            <asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />
            <asp:BoundField DataField="content" HeaderText="content" 
                SortExpression="content" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:canhbuomxanhconnectionstring %>" 
        DeleteCommand="DELETE FROM [Jobs_lang] WHERE [id] = @id AND [lang] = @lang" 
        InsertCommand="INSERT INTO [Jobs_lang] ([id], [lang], [menu], [title], [content]) VALUES (@id, @lang, @menu, @title, @content)" 
        SelectCommand="SELECT * FROM [Jobs_lang]" 
        UpdateCommand="UPDATE [Jobs_lang] SET [menu] = @menu, [title] = @title, [content] = @content WHERE [id] = @id AND [lang] = @lang">
        <DeleteParameters>
            <asp:Parameter Name="id" Type="Int64" />
            <asp:Parameter Name="lang" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="menu" Type="String" />
            <asp:Parameter Name="title" Type="String" />
            <asp:Parameter Name="content" Type="String" />
            <asp:Parameter Name="id" Type="Int64" />
            <asp:Parameter Name="lang" Type="String" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="id" Type="Int64" />
            <asp:Parameter Name="lang" Type="String" />
            <asp:Parameter Name="menu" Type="String" />
            <asp:Parameter Name="title" Type="String" />
            <asp:Parameter Name="content" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    </form>
</body>
</html>
